##############################################################
# Use this text file only if for some reason you wish
# to do a manual SQL table install.
# *note no need if you run the supplied ezportal_admin_db_install.php
#
#
##############################################################
CREATE TABLE `phpbb_portal` (
`portal_name ` VARCHAR( 255 ) NOT NULL ,
`portal_value ` TEXT  NOT NULL ,
PRIMARY KEY ( `portal_name ` ) 
);

INSERT INTO `phpbb_portal` ( `portal_name ` , `portal_value ` ) 
VALUES (
'welcome_text', 'Welcome to <b>My Community</b><br /><br />Thanks for using ezPortal,<br /><br />Have a good time! ^_^'
);

INSERT INTO `phpbb_portal` ( `portal_name ` , `portal_value ` ) 
VALUES (
'number_of_news', '5'
);

INSERT INTO `phpbb_portal` ( `portal_name ` , `portal_value ` ) 
VALUES (
'news_length', '200'
);

INSERT INTO `phpbb_portal` ( `portal_name ` , `portal_value ` ) 
VALUES (
'news_forum', '1'
);

INSERT INTO `phpbb_portal` ( `portal_name ` , `portal_value ` ) 
VALUES (
'poll_forum', '1'
);

INSERT INTO `phpbb_portal` ( `portal_name ` , `portal_value ` ) 
VALUES (
'number_recent_topics', '10'
);

INSERT INTO `phpbb_portal` ( `portal_name ` , `portal_value ` ) 
VALUES (
'last_seen', '5'
);
